from sqlalchemy import CHAR, DECIMAL, BigInteger, String, DateTime, Column
from config.database import Base


class FundTransfer(Base):
    """
    银证转账表
    """

    __tablename__ = 'stock_fund_transfer'
    __table_args__ = {'comment': '银证转账表'}

    id = Column(BigInteger, primary_key=True, autoincrement=True, nullable=False, comment='主键ID')
    transfer_date = Column(DateTime, nullable=False, comment='日期')
    transfer_time = Column(String(10), nullable=False, comment='时间')
    amount = Column(DECIMAL, nullable=False, comment='金额')
    operation = Column(CHAR(1), nullable=False, comment='操作')
    account_no = Column(String(64), nullable=False, comment='账户')
    create_time = Column(DateTime, nullable=True, comment='创建时间')
    update_time = Column(DateTime, nullable=True, comment='更新时间')



